Transforming your time data (plans)

Format: 15-min increments date time category notes 1/1/19/0:00 Routines 2013-12-21 duration 15 Category, Duration Categom | Date Day of week: ST Use a pivot table = Routines 30 Duration date-dayofweek (date) Sleep 75 个 Month: date- Split by day DAY (date) +1 1/1/14/0:15 1/1/14 0:15 Routines 1/1/14/0:70 Sleep 15 1/1/14/0.45 Sleep 15 1/1/14 0:00 Sleep 1/1/14/1:15 Sleep 15 1/1/14/1:30 Sleep Provide workbook 15 15 to sum up durations by category → use copy and paster! Format: times to comp, A (split date and time) date time, category notes I create timestamps, column with both info (date + time) 1/1 10:00PM Sleep & Two entries 1/2 12:00 AM Sleep Need to split by midnight 1/2 7:00AM Routines Ceasier when you're entering data) AtaBuratty calculate midnight splits complex function... provide VBA? Workbook? Copy data & offset it (easier than formula) Calculate end time: Sort by date/time. Add column: - (select cell below) Calculate duration need ; Hmm.... I might need to teach pivot tables here... I'd rather teach people how to analyze their own data instead of making them reliant on pre-made graphs subtract end time from start time, Want it in hours? Multiply by 24 January: Plan short video tutorials Weekdays weekends, or day of week Date-related functions